SUPPORT / SAMPLES & SAS NOTES
Problem Note 65967: The Select Data Source Items window displays a maximum of the first 1,000 columns from a table
 |  |  |  |
The Select Data Source Items window that you can use to select columns from source or target tables displays a maximum of 1,000 columns. This window appears when you are selecting options for generated transformations.
If a table contains more than 1,000 columns, you are not able to see or select the columns that are numbered 1,001 or higher.
There is no workaround for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 R2 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 4.7 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 4.7 | 4.904 | 9.4 TS1M0 | 9.4 TS1M6 | ||